About

The tech industry has experienced unprecedented growth in the recent decade, revolutionizing the way we live and work. Moreover, the rapid advancements in technology has created compelling investment opportunities, attracting investors to seek additional income from the stock market.

The Big Tech Stock Prices dashboard intends to provide a summary of the past stock performance for 14 big tech companies. It also enables the user to compare between the stocks and use the moving average indicator to further analyze the price trend.

The data set is obtained from the package tidytuesday from week 2023-02-07 and is originated from the Kaggle data set Big Tech Stock Prices. Please see The Data tab for more details.

The Data

The stock data for this dashboard is from the package tidytuesday from week 2023-02-07 and is originated from the Kaggle data set Big Tech Stock Prices. It contains the stock prices for 14 big tech companies from 2010/01 to 2023/01, and the data for different companies cover slightly different time ranges. To keep data consistent among companies, entries in the common range from 2012-07-01 to 2022-12-31 are used.

The data dictionary for the two files in the dataset is recreated below.

big_tech_stock_prices.csv
variable class description
stock_symbol character stock symbol
date double date
open double The price at market open.
high double The highest price for that day.
low double The lowest price for that day.
close double The price at market close, adjusted for splits.
adj_close double The closing price after adjustments for all applicable splits and dividend distributions. Data is adjusted using appropriate split and dividend multipliers, adhering to Center for Research in Security Prices (CRSP) standards.
volume double The number of shares trated on that day.
big_tech_companies.csv
variable class description
stock_symbol character stock symbol
company character Full name of the company.

Below is the stock data combined from the two raw files.

check the start and end year for each stock

static 1 - sub tab (by quarter and by year) plot overall increase/decrease in price (percentage), and average daily volume

static 2 - table summarizing the recent growth for each companies (recent year)

interactive 1 - compare two stocks (price and volumn), change date, select companies, whether fix scale

interactive 2 - select one company, draw moving averages (select the averaging period)

analysis -

Past Performance Summary

Historical Returns

Compare Stocks

Chart

Draft

Column 1

Carat

Cut

Colour

Column 2

The largest diamonds